UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EXRzt7WnU0iophtbQzdxZWt/nzEsaHPRwP78lf4qJ4g='
WHERE
key_id = 'b81e16a141572641c0230a4bd14aafb49251fc01c468ac1a1a3515e865f16471'
AND (
token = 'EXRzt7WnU0iophtbQzdxZWt/nzEsaHPRwP78lf4qJ4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)