UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Nl/7G8kYXgFbSJZ4WHwpedmNPCIRtK12gYRgCkA0F8='
WHERE
key_id = 'a91a7290b2fc699eb5f53cb65a0a0ec95754979f3a8fcadd3be62343a4b14366'
AND (
token = '9Nl/7G8kYXgFbSJZ4WHwpedmNPCIRtK12gYRgCkA0F8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)