UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JW8lgMWlGoy0TpMW8MhMbcBZoNNLboO85EsC5PZ88Eo='
WHERE
key_id = '1163f6f03189cfd4298fa7e9ea7e369f9efaef2bf0ba750853cd66f534054f99'
AND (
token = 'JW8lgMWlGoy0TpMW8MhMbcBZoNNLboO85EsC5PZ88Eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)