UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4a6aGnLKeb4oBEn751+NChiAr5LvCLGoMjjDMjcKiAw='
WHERE
key_id = '1f87040de472d93a8e5dc804e0ffe1bdf40adf7af4120685c0978e7b0de220ea'
AND (
token = '4a6aGnLKeb4oBEn751+NChiAr5LvCLGoMjjDMjcKiAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)