UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DcGZdeyMN+lIki9zSfd/a7xJK54fxBz7MIiHWcqlb6I='
WHERE
key_id = 'd416b612b9dcd51eda8c64de9406a6fe00a095423a80825610a85d8a13855468'
AND (
token = 'DcGZdeyMN+lIki9zSfd/a7xJK54fxBz7MIiHWcqlb6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)