UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jIv0HM/pwYNmBCrFE9AyewJMvEfIbyQp0FWi19rpn84='
WHERE
key_id = '7b9d0cfb7c13c012469735fd160aea65c4a30d26b058010e1870559e1d69afdc'
AND (
token = 'jIv0HM/pwYNmBCrFE9AyewJMvEfIbyQp0FWi19rpn84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)