UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HfhBCSq7fq5FGrp5rY0qrYUuRCeJAuUB/aoWnCetOUc='
WHERE
key_id = '2caab56b3a70221855d4ddb3e70936fde69eefae0fbdf241d2b29f2bf275af78'
AND (
token = 'HfhBCSq7fq5FGrp5rY0qrYUuRCeJAuUB/aoWnCetOUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)