UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OnPZf1Lx+Kvq0WGpe1u4IAdo7x8Wh8HgvZVcKYzSvp8='
WHERE
key_id = 'dcecd91d5919fc0c4b6a1318294195c41dc9fd87e488b8900277a490a3fd40d0'
AND (
token = 'OnPZf1Lx+Kvq0WGpe1u4IAdo7x8Wh8HgvZVcKYzSvp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)