UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jJ2PNE9KX9amvWhErvO+I8sw3nqsfl7KnnIFLHPNr3k='
WHERE
key_id = '36b694e2198444bcc75bab2e12dc7e18123a8b7835672c0eb4a01e38a4820b4e'
AND (
token = 'jJ2PNE9KX9amvWhErvO+I8sw3nqsfl7KnnIFLHPNr3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)