UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hkCjWRLGy/qpaVrBOTXGysiSsqUzSJzISpX9QiKMKxU='
WHERE
key_id = 'a6286a5e14673194fa0adbcddaecfde63c188fb7dff8dd600ebfb9ffda9cdb26'
AND (
token = 'hkCjWRLGy/qpaVrBOTXGysiSsqUzSJzISpX9QiKMKxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)