UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1vmi6oA2nEkCSHVQE2zzPZN7PHvRzhqAdxA0tzJoCk='
WHERE
key_id = 'a5e557a6470a51f2852d5ea281e0fc561dab580483c340b66d667b28c7c7f00a'
AND (
token = 'X1vmi6oA2nEkCSHVQE2zzPZN7PHvRzhqAdxA0tzJoCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)