UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jUN7ya34qHhBZJG24Dgy8CFMYZkE51FSDilN+IPYCTo='
WHERE
key_id = 'b5684368357799d3e3f71746f14392f9c1af9426d686603e205dac8cc4ea5ace'
AND (
token = 'jUN7ya34qHhBZJG24Dgy8CFMYZkE51FSDilN+IPYCTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)