UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z8Wm9aowGwjkBLFKgG/67oP85BsLH0Zl72IhLsCVWoQ='
WHERE
key_id = '3cc9ab1d667100bda4fbbf5ec7eec902be965c64c09d61b8b2e48d6086dd02de'
AND (
token = 'z8Wm9aowGwjkBLFKgG/67oP85BsLH0Zl72IhLsCVWoQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)