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