UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cN5936E+mH9ytQ1i/yYcz8k95aSUXc08ENO54wgprpM='
WHERE
key_id = '1880d91d702c29642ca4880acaff3c926f54968df1ebdaee07d9986a553475f0'
AND (
token = 'cN5936E+mH9ytQ1i/yYcz8k95aSUXc08ENO54wgprpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)