UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6za1pJ+cF+RoPWcBrYMz0To6U5f7cC/1iIFpnxKNrXI='
WHERE
key_id = '8b720097535a349deb3205ce825e52bb568a4e869d1c24d84f4f794eee7fa547'
AND (
token = '6za1pJ+cF+RoPWcBrYMz0To6U5f7cC/1iIFpnxKNrXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)