UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zwtXQykPsPiPoS5StSbWcPL0MjrcxtTdUZ4XDN25uNQ='
WHERE
key_id = 'b2927ac75a4663e80598bd643587eb01b7dd6af1f8b29ebabb6ec80c47d49c9f'
AND (
token = 'zwtXQykPsPiPoS5StSbWcPL0MjrcxtTdUZ4XDN25uNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)