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