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