UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SNonR1zc1im/yD27Bdw7XEMH9zcEsAhPWldoh8aFpv4='
WHERE
key_id = '8b1223c46e108b8dc13984ff19da517f7ef791568a4907cf4fe4cf47756043e2'
AND (
token = 'SNonR1zc1im/yD27Bdw7XEMH9zcEsAhPWldoh8aFpv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)