UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Q7tm13Q5T8kQbuFeTFoV6/wHPL9nPhEstmYoCX9Ohg='
WHERE
key_id = 'a53c4643b0ed8d1fff0843fe03fb2fe149d12a2d22f40fadbd58e056f83e6694'
AND (
token = '6Q7tm13Q5T8kQbuFeTFoV6/wHPL9nPhEstmYoCX9Ohg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)