UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RnyODL5ppLdM4EPTNiBGpiJ2A6+ycbpMvCTr+Wrj/y0='
WHERE
key_id = '9a8ab5319239a6ddef19b6901c9ce8960a6c9fe25543a80c88e42d8b6e4fe703'
AND (
token = 'RnyODL5ppLdM4EPTNiBGpiJ2A6+ycbpMvCTr+Wrj/y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)