UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wnLuKk+NKANsD3w/IWFUO/VCHxbYn8GyNeFpbvaIas='
WHERE
key_id = '59ef12ad2edfa61b4821af8edd29eee6ac1f19c55245d8b49bd9be869373d182'
AND (
token = '9wnLuKk+NKANsD3w/IWFUO/VCHxbYn8GyNeFpbvaIas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)