UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TlegIg5xh2acZFPdahJYy3Gp3AJEufh3IhpGRb0YDhk='
WHERE
key_id = 'defd34d84720ca1e95906c191346d1fee978b7b1f91405363af753aad4394f94'
AND (
token = 'TlegIg5xh2acZFPdahJYy3Gp3AJEufh3IhpGRb0YDhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)