UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cglWBBigA7E01aJE99UWQOZHImkxhMdactqPdMsV4rs='
WHERE
key_id = '4e8470bd61a7120d4b1c7deb20d8fdbe6c674ef70f83e6d3dbc2e01b73eaaf7a'
AND (
token = 'cglWBBigA7E01aJE99UWQOZHImkxhMdactqPdMsV4rs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)