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