UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WTQNGC+ZeRF5xqi66z8Qsy4Y3L3oFdBajqwyI76SuYA='
WHERE
key_id = 'e8260c5974d8677efe5cb61ef9572901e3c5a01e0801960de29bb5f2647488f8'
AND (
token = 'WTQNGC+ZeRF5xqi66z8Qsy4Y3L3oFdBajqwyI76SuYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)