UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQ92ETcD3YhB/ZNUlUauL3JRuU8rdOYLS2KCGOiryIs='
WHERE
key_id = '11a7059d3cbdf0a9c2e95a4f53cbba813fea15f8178d09b17a83b1f5c7441e8a'
AND (
token = 'HQ92ETcD3YhB/ZNUlUauL3JRuU8rdOYLS2KCGOiryIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)