UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ts+VNM7sPxqAfsDjV779+2DdsEHxj2Tm/zaqMembAi8='
WHERE
key_id = 'e850194abc21adca649ca3d155570fc24d6228e1f1f7e16a5cf26aeac32b122c'
AND (
token = 'Ts+VNM7sPxqAfsDjV779+2DdsEHxj2Tm/zaqMembAi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)