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