UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hk5PX8jpNYDxBfNRsOYz6Nk3Fidol1cT1DV4X2LX+hw='
WHERE
key_id = '623676dbb398f7e429a64c430de4355cf26a4182a99e4295ff5ab84391cd3b4c'
AND (
token = 'Hk5PX8jpNYDxBfNRsOYz6Nk3Fidol1cT1DV4X2LX+hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)