UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1IrUA4VjsQektNpKENLf/ccD3ixmNZDAoDeLH6m9Tw='
WHERE
key_id = 'b9cf2ab56b469253ff9aa6bca451a4bb41b187490c7327d149f15a55ef85c4cf'
AND (
token = 'W1IrUA4VjsQektNpKENLf/ccD3ixmNZDAoDeLH6m9Tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)