UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uoeBO/KEvD2gpSt4k8OzZWJ9y3LMSEIC7WudJE/UNsI='
WHERE
key_id = 'c9c0cae0f854ac877c55ecc4780e0fc24a0bc5456f1661f2a126308b205bdc0e'
AND (
token = 'uoeBO/KEvD2gpSt4k8OzZWJ9y3LMSEIC7WudJE/UNsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)