UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fBWP0n0YCKUeHX0r/5LNP6/TaVX3qASsoAKiDES77i4='
WHERE
key_id = '7fecda7b97da53da057855ac1ac059906660252938227d4d3e427aa0cc11e8d5'
AND (
token = 'fBWP0n0YCKUeHX0r/5LNP6/TaVX3qASsoAKiDES77i4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)