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