UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBBKGSMo07R7JK0cXtk/nxcmRJajUbiaMcHq/E+6gX0='
WHERE
key_id = 'c6e32f6dc3e206e5904949f050b92690039cd7e420ad8bc3804ec38de03a5a3a'
AND (
token = 'pBBKGSMo07R7JK0cXtk/nxcmRJajUbiaMcHq/E+6gX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)