UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r5PUh/8fgYzZs7H50z59UtbD5tRFbi0FHUfFuiB6u0w='
WHERE
key_id = '855b49192546d4621a213b1cfc22c46608bf274ec4d3dc6bf8d75806111ca22e'
AND (
token = 'r5PUh/8fgYzZs7H50z59UtbD5tRFbi0FHUfFuiB6u0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)