UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pbMv2hk7mIEVJf7R4hnpW6soZC5Q8PAFIQvghuudZWs='
WHERE
key_id = 'c0540a7f1ffbfa3fc0db59ec7cf13b1f476f94b3d6d9a09834395df2ee815946'
AND (
token = 'pbMv2hk7mIEVJf7R4hnpW6soZC5Q8PAFIQvghuudZWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)