UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9l/ioXWvD6IHi3sg14tT+nrhSAcxgPyn+AU9fFyUks4='
WHERE
key_id = 'f82ba9258efa71a661413cf3bac2bf570b28fb01e76c010d51b6cb3e7fb4fd26'
AND (
token = '9l/ioXWvD6IHi3sg14tT+nrhSAcxgPyn+AU9fFyUks4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)