UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9p37X4qSF88msla1ChwQX7k4QJFlUy8PUnZ1g3b1Uwk='
WHERE
key_id = '2b8788c29324d14f7aecc8a38e83ee5e41f754a991c5503c06ff04b9d1184b8c'
AND (
token = '9p37X4qSF88msla1ChwQX7k4QJFlUy8PUnZ1g3b1Uwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)