UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pChJ8e2vOPkmBgIhwszwVBLbYUAJP0aw8x7jbF3G9+c='
WHERE
key_id = '004456a832565e10ba59dd008b420ca9d871112b4ca7856e4946f864c29eb8ac'
AND (
token = 'pChJ8e2vOPkmBgIhwszwVBLbYUAJP0aw8x7jbF3G9+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)