UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8HsS8CSHjOV9FCXU1oTu8jYk6dWBmzfGaXU83OuLRTw='
WHERE
key_id = '1d6c0b0c90f299b9e67d95bd732c93f340addc7999b4c0443060ce8dec831280'
AND (
token = '8HsS8CSHjOV9FCXU1oTu8jYk6dWBmzfGaXU83OuLRTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)