UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kPPlYFuFTcSvsIC4GT/XlgxIsjRQ1tCGKn03SHs4elY='
WHERE
key_id = '0099c5a1af6d075a601b0211c62d4fb4685d5bccd721153e0bb2fb2e558aac80'
AND (
token = 'kPPlYFuFTcSvsIC4GT/XlgxIsjRQ1tCGKn03SHs4elY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)